Practice Test

Q1) A function must not contain another function in its argument. Show Answer

Q2) The functions UPPER() and PROPER() do the same thing in Excel. Show Answer

Q3) The TRIM() function removes ALL blank spaces from the string argument. Show Answer

Q4) The LEN() function does not include spaces while calculating the length of a string. Show Answer

Q5) AVERAGEIF function cannot ignore non-numerical data in a range while calculating the average. Show Answer

Q6) Which of the following is the correct syntax for the COUNTIF function? Show Answer

Q7) Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell? Show Answer

Q8) Which of the following functions (s) can be used to find a character starting from the starting of a string argument? Show Answer

Q9) Which of the following functions (s) can be used to find a character starting from the end of a string argument? Show Answer

Q10) Values used with a function are called: Show Answer

Q11) A cell A1 contains the following data: MUMBAI-400020. We want to store the PINCODE separately in another column, say column B1. Which of the following functions is most appropriate? Show Answer

Q12) What is the purpose of the COUNT() function? Show Answer

Q13) A(n) _______ is tested in an IF() function to determine if it is true or false Show Answer